In SAS^® Data Integration Studio, when you use the BW Source Designer to create table and job metadata for transactional Output Delivery System (ODS) objects, the creation of the metadata fails. You might see an error like the following:

SAS code execution completed with error.
SQL query "select distinct t1.name, t2.dimension, t2.dbmtxlg from 
work.list_of_tabs t1, work.DATAMODEL t2 where t1.bwobject=t2.dimension and 
t1.table_type='DIMENSION' order by t1.name; "failed: Unable to execute query:
   ... 
   Do you want to view the SAS log: 

The problem occurs because the underlying product, SAS Data Surveyor for SAP, does not recognize a transactional ODS table as an ODS object.

A temporary workaround is to change the information about the ODS in the metadata extract. After the metadata extraction is complete, submit a simple program like this:

   libname r3lib 'C:\temp\06102008'; 
   data r3lib.rsdodso; 
      set r3lib.rsdodso; 
      if odsotype = 'T' then odsotype = ' '; 
   run;

This problem has been fixed in Release 4.3 of the SAS Data Surveyor for SAP.

Operating System and Release Information